SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403240 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403240 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233742,372873,567101,659989,452167,610014,454896,983466,356539,850604,297434,1029894,970672,203863,88764,54145,29179,842467,913248,735576,187490,305633,779813,882119,545589,729592,413145,346331,952138,67748,938710,967486,169120,863350,400017,376804,334258,1010211,229068,278118,417752,431402,844830,811485,880128,746866,1035781,697852,698969,955201,571037,22574,25296,1003695,104631,622408,997626,339694,676558,381026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]