SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562328 LIMIT 1 [ RunTime:0.000720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562328 [ RunTime:0.007627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899769,798467,1043694,805063,33211,632189,931717,280159,506229,711810,862136,382672,187246,211444,408582,193891,991460,169263,29531,1017525,1004020,486109,415017,839335,185822,48853,573476,644435,118549,885165,925137,499228,203406,667291,232010,980069,160337,915816,300860,951984,700124,578101,66756,687011,432138,344067,773691,875414,251280,731998,215781,464683,812043,444163,159372,106814,781149,491488,117624,503140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004677s ]