SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563590 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563590 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039583,92292,111498,415101,654969,375912,515879,137284,320840,438387,828502,450241,216610,94955,783582,423488,985871,805539,671201,982945,588814,523275,398156,356755,106577,40992,999520,182224,1042852,968542,150661,1019519,917180,365657,771326,813116,543761,793894,261534,630074,399722,668661,524516,198810,85460,883413,767137,1047763,469097,852943,643167,957404,927295,290544,136401,284411,170697,313725,689896,398446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]