SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008374 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008374 [ RunTime:0.003438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544226,93199,931274,183332,398118,724184,787138,853832,794454,1011315,797266,750131,18975,278154,600041,653590,762960,785871,228871,273686,148566,476234,1016044,1010779,1005343,454590,814441,841782,542774,65030,468038,647702,172857,1027557,932507,617450,432364,664091,104630,74661,295080,453834,806742,388553,906294,174132,866804,715500,168272,477062,976266,848373,427072,382241,857606,1022624,852034,765538,555462,991366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]