SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591299 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591299 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248451,169118,454808,1036610,1020678,416747,294778,596872,427003,966398,846936,863573,216367,956446,893672,6499,147150,94477,354774,972031,508547,375762,322346,935888,36897,552489,285825,457794,182722,341391,447433,50404,913543,553203,1014849,712056,273415,1019390,31520,383579,514601,379123,105813,1029756,699414,917339,822009,570235,164052,280963,273184,53261,759589,406210,823031,752022,521719,201430,432079,71379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]