SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535945 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535945 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478994,322821,123398,98235,940336,405974,541175,417287,377331,947683,669161,980916,836960,978793,466027,742413,317441,992769,712594,799178,18397,120588,919893,857106,803967,338720,168264,800785,580940,972245,391207,151073,887661,408293,798276,829713,1037881,269361,499449,975279,784582,759898,182909,320011,586234,986881,350552,268685,362780,711200,807995,179958,752306,285197,648276,595966,351019,626369,937944,422110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]