SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983904 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983904 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229969,432661,392366,412445,411947,212810,1030556,506434,633793,105930,371202,125357,312328,795316,889488,633043,293508,33191,565156,242200,864324,14394,882325,579531,114702,738308,544056,843258,80613,640532,209805,186869,249101,201256,722276,817511,223311,65527,357445,753046,418638,847902,661437,351231,251797,888232,1017278,417143,312778,818992,561011,868574,374879,130950,746717,224486,543604,269328,797569,301907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]