SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981671 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981671 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759805,565907,1014291,59504,136723,164276,6074,655863,729144,1048581,743030,928625,546120,1015165,233205,450412,84914,52785,1037088,902535,160950,391657,700262,200419,766650,950247,909259,296725,48307,499268,457426,892513,194520,504054,715617,46009,324486,147778,516446,96697,923634,255113,291338,312496,347353,424445,529147,482358,305291,355999,1030796,494581,377231,395774,392770,452717,963413,365540,44378,731524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004084s ]