SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482087 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482087 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822770,885444,626334,1016609,418831,441918,47610,83334,453358,553200,948106,417427,368861,1025998,719032,688489,1686,177068,298138,811712,528001,708519,517749,102394,566916,453761,83732,802928,356225,233722,377825,310217,937060,354783,1019899,211887,80756,968252,379128,560363,468149,425748,333574,857305,426256,87690,780460,968040,770340,199966,178343,998031,956223,415246,415775,965161,484767,285672,417242,533553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001111s ]