SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042371 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042371 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28429,885844,426073,452792,71105,79982,752921,416121,969728,43982,175851,244511,446839,907323,87458,29667,51182,854318,781505,759240,600685,544123,782883,367336,222321,330816,712485,567464,500214,315109,867872,315587,608791,69986,492508,254830,776398,978865,876422,803382,862411,452385,271664,637421,700359,280867,2069,593952,642955,684109,415092,139742,922641,996496,336859,865939,486703,516160,767142,904549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]