SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541752 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541752 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781778,63618,209416,124283,71361,542058,39578,76736,2180,903944,341279,646242,1019285,163822,960468,667819,71053,593888,152070,230613,120674,911808,733667,720730,517905,163153,95280,163334,862548,584089,269684,277376,695216,516728,155314,18337,44231,686682,6738,844543,501462,199631,547131,321661,973178,148786,840057,685086,860653,133848,930005,507263,888534,557690,322859,10180,568557,587686,400333,213886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]