SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201621 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201621 [ RunTime:0.002775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550497,257106,254556,884147,309414,857017,969728,95070,135758,927991,977497,848824,372861,556198,1019474,538276,708442,546624,724112,162990,951459,202517,51852,868404,789061,313122,929054,898099,932916,42797,810972,796146,904960,1007200,422407,561804,203343,453151,316533,971543,674044,947332,465109,636776,32031,415872,106585,410147,1029586,239319,432333,772320,579778,188911,686233,63578,454743,980887,421242,1041602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]