SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142201 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142201 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41376,403983,84237,1009688,644309,936544,1048493,355548,520354,500791,860054,651453,813078,616453,735916,244102,347766,633744,539260,206080,796510,968662,923736,815429,540105,38923,967212,125087,495611,536954,714466,909535,807144,377672,982687,789479,168571,1040405,686385,163594,14691,447281,477844,595378,689989,106456,720796,915294,177445,1023306,1002803,941742,981007,93156,645089,316244,116869,796952,73718,481318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]