SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400107 LIMIT 1 [ RunTime:0.000951s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400107 [ RunTime:0.003802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14905,755520,378098,315738,286447,45511,979263,858427,867347,74518,138684,340401,844159,802323,683566,208655,668765,223343,126789,945845,627793,27191,603311,128170,894382,848561,598707,190110,626023,1022767,61356,508698,422956,287584,1011274,715337,347836,846643,103123,143710,489453,1046055,149549,786050,494022,529488,442637,912004,552848,817891,129731,842266,264039,95543,76619,465329,919305,507050,359934,919412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001285s ]