SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047644 LIMIT 1 [ RunTime:0.000710s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047644 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421904,513102,437915,894953,244618,235958,286805,1027333,348657,970751,1045004,902916,201205,537395,592987,584005,1002605,555306,548331,1006254,854845,566001,733719,163912,52492,759950,400152,618982,215059,880312,876991,652776,562931,47992,274376,988818,305192,543790,1036444,643969,507909,373328,185249,167252,919124,1034626,159730,938081,984426,615906,348792,353996,691111,1039546,918628,947415,384278,547520,372156,217408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]