SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013612 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013612 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205691,894905,495707,955342,364820,532572,1033560,4547,606439,532648,452796,172484,815743,103643,182376,1032366,934505,866549,458736,289971,486469,601991,879202,336972,490000,393476,813660,90125,645910,498610,116250,1025669,695888,75808,950703,842251,40177,1037703,137615,166681,829480,235517,882161,1036235,210433,654877,613234,603099,99446,459967,435804,160246,316908,41051,26456,654696,670025,867133,851662,349300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]