SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461028 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461028 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567044,720665,281366,1022889,402014,359553,579234,737142,871239,574471,834279,93954,747081,756802,1030262,179349,401481,541619,7039,291511,85526,41935,660484,639888,294243,700492,15605,871049,1026818,293682,792181,369722,532958,535993,279503,938715,255392,248043,408649,931400,953469,859727,298933,374106,933378,494060,109872,557197,382035,983682,314396,597409,669533,485191,60616,397292,13434,385581,623594,113640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]