SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193923 LIMIT 1 [ RunTime:0.004438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193923 [ RunTime:0.004288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720197,540610,832166,1010390,802797,544877,429698,540085,756696,228171,280504,357795,449145,1007689,237541,99498,866420,333319,801877,8594,503516,262521,951480,884680,495414,348643,794747,545407,910774,112932,526593,300182,584223,646224,187273,507105,59431,179953,1008489,109331,570264,962906,408700,354022,977676,890147,256314,1022058,458239,980337,562653,600810,297628,634592,919672,1005356,855020,976166,570567,39505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001872s ]