SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105854 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105854 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436516,876519,913433,621927,598968,990899,188120,1045258,593628,820698,112822,962674,972194,466794,528389,856642,880152,936112,928039,304943,469281,563972,488699,166660,53838,235400,405526,997863,567977,58474,385843,433289,138306,891064,138864,829609,712765,242740,64879,1000782,382372,807762,369033,24777,142340,525415,538217,937758,823422,664101,168238,1027864,425651,41424,111148,450152,91624,912276,1005804,430708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]