SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438047 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438047 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685965,253285,24773,941095,886949,689247,180925,639220,943516,431494,842591,1036779,276859,70034,127828,616031,658995,166134,257388,117600,998997,622184,86056,553279,180438,601062,896745,465762,296856,832080,138452,195821,882778,242501,8163,691595,377498,449174,852283,803674,139389,1019332,159687,971058,37885,165840,488615,320842,811684,334176,191172,318878,530955,199991,642886,14363,732757,889246,695882,183188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]