SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 847020 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 847020 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045035,676858,588088,800818,238161,387593,461231,1015226,1007110,600004,764534,295458,737170,854195,102882,420604,242929,285897,645564,999114,59853,1003144,75811,218964,146951,423118,639898,882195,295837,806516,748011,873202,656239,586388,501044,730767,365232,113732,625513,947635,843907,21580,355386,963576,337862,1018762,804393,956424,297595,4734,885694,749247,464398,435487,364630,229355,940582,233725,852062,941013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 847020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 847020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]