SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525865 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525865 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529029,60918,185419,772851,815307,254402,314930,1033841,714608,539181,1026124,806249,250002,653590,942222,244747,409537,314199,588708,903905,279089,256440,23984,700923,9774,360521,251494,834046,871549,228937,502407,107424,771366,899270,903551,28470,546604,528512,362207,800173,661466,962667,67669,396449,562082,922263,249871,165900,477572,29856,934160,424493,614916,193580,594595,410241,858311,917842,314083,837952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]