SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475193 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475193 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584588,459215,56236,985388,309165,153979,452587,862898,784365,366158,494959,854156,220465,563675,1030564,225354,947462,710091,331127,127742,606565,270839,553329,144824,869272,488094,640870,564649,644162,545557,274097,833192,145395,357590,926107,899443,656996,1015459,466002,55640,293809,982610,878665,987520,759140,669028,620741,386744,1045052,167250,341354,306405,366387,236890,345926,709183,166492,529153,306945,363803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]