SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566207 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566207 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405326,742376,610623,267571,208029,525461,205112,113714,680545,185894,659447,119001,319453,22928,410735,738601,230693,896588,237675,533403,152839,429509,356546,1034449,629268,387272,32020,561917,235287,180040,237503,164761,547845,856195,228723,712950,588277,404713,467349,653288,870828,834288,584545,666185,479545,360011,905392,823642,882662,164899,455094,899682,447090,91565,1022999,702007,157106,820111,452233,823449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]