SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451950 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451950 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377782,712836,31129,640418,77780,23674,484203,778612,506283,790139,44644,261718,268840,869781,32433,739715,491382,773823,889283,1042879,225903,904649,637021,166189,185453,632992,199600,663120,929384,512449,519594,93618,553954,230382,561425,115815,434148,575964,879308,689095,366486,450055,434584,80059,956488,653453,1009358,425012,143119,594644,545502,942552,259628,35817,510622,538177,810964,1039990,784704,355716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]