SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501265 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501265 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392144,828571,494768,862024,401667,831741,807830,1026365,134961,346500,451590,943437,305503,935525,793354,905874,415665,963387,28688,698329,413862,753545,43057,213309,223227,609546,562471,627272,669697,345928,388309,134340,786411,328425,856577,606158,419782,784577,806086,478872,970111,531074,185890,5029,1040109,589346,348131,1029190,791325,785996,345069,591025,1026960,775426,189914,402267,911812,883979,570297,1012190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501265 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501265 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]