SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50621 LIMIT 1 [ RunTime:0.002493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50621 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912159,766857,486497,945908,955389,676574,391646,336112,90577,1047838,140775,208015,805260,550353,381864,564270,504637,478727,152557,764323,441038,1044712,569552,9993,370262,299796,339292,489195,385856,783411,269312,225202,170585,695215,32201,261959,805316,643457,1038850,225951,375696,164067,88635,354845,143534,645356,438387,950407,90386,936225,992853,747793,315951,308627,695051,972254,951686,403016,744179,279588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]