SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521042 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521042 [ RunTime:0.002527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013907,558619,92282,285631,873380,456414,857787,103765,255985,988378,914939,10900,885395,911952,895590,456572,518661,971654,511316,186262,171203,292480,709609,766460,77603,502242,974777,736671,403507,936388,963627,300500,116239,1030844,289743,450647,435452,642683,866589,915550,1022049,215574,1013443,315062,951032,156724,675224,1019373,691210,618325,792064,528694,549993,248967,1004387,273222,905707,786544,184670,577175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]