SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49974 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49974 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923008,386353,331437,520777,887544,175916,752567,318840,491739,444958,856098,1042933,343087,999068,706292,959021,327044,101421,640723,292814,833052,457740,196934,246141,517778,161056,307227,792097,649021,836739,223075,67262,302875,41601,316321,648441,437845,541889,530681,973955,605624,352348,329172,83882,753790,889878,17545,109255,710699,641732,475178,432784,98299,238226,746944,881913,458382,807852,32301,309212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]