SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017436 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017436 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634868,558710,445983,303717,312400,331441,439141,175725,833903,543115,320805,235098,521261,215633,599593,834089,587286,736468,181286,871338,627750,242308,971500,372298,404642,194007,550191,51931,95776,646231,592193,413232,168358,869233,640753,154251,582005,738064,674168,279401,56666,457467,656990,513724,553423,932501,558853,97518,82799,588952,351964,580065,253311,479751,347050,1007090,484567,34931,319720,29092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]