SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046303 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046303 [ RunTime:0.003047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889840,923942,553923,1026948,92431,873311,542657,821414,623943,165850,85746,143977,926535,77867,273894,801298,376482,662492,241779,548497,563825,218986,863028,117006,140017,984543,356059,825413,88424,524955,406487,814022,493885,581697,563658,141726,836768,919835,273185,145533,865852,558356,139055,522762,970984,1027047,838715,412323,917666,854232,1011615,143152,856707,808012,554844,927994,551014,526602,577074,273092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]