SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042969 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042969 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428122,991668,1027714,1013300,669287,84263,366386,581717,751326,579547,96245,605717,687390,827445,89574,755011,664559,996875,344514,229793,776594,122589,99520,414891,14672,564939,561563,86879,55117,515996,441808,412385,591493,956728,641273,486599,38719,140220,905038,293793,175453,423308,280292,116382,207580,869947,704873,1018098,653445,176893,966088,11890,389667,409375,747747,85826,994059,557974,955329,146611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]