SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312843 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312843 [ RunTime:0.003196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486642,196728,544334,834259,247968,37187,885434,1010919,890281,606254,670680,578650,512312,722072,421321,1048085,795861,1040089,546843,700747,44850,588983,307131,490146,883719,786980,222775,656815,783809,111160,473769,100555,971495,532643,621805,281825,499662,121666,902137,662019,265079,747772,871387,929317,618493,333498,69874,402923,815415,1015776,457654,692360,444774,378448,168477,976101,345208,504645,260017,911498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]