SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371010 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371010 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209827,750883,1043198,451346,1041977,516934,309693,827077,92459,450776,317201,768486,759081,627326,1000459,994500,851595,566680,352207,256495,262224,240450,571287,873182,192160,596805,544305,547391,893184,345606,255845,567250,648778,136980,974941,446609,206925,835702,395703,179164,132162,593311,38891,354998,690804,831452,8848,1001812,747283,23647,436608,995339,3733,244429,372662,731439,166534,444218,737057,153860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]