SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503743 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503743 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911283,331047,915838,966762,584818,627234,590703,819734,255100,894996,539255,84258,579405,537930,145793,17956,962823,426713,514508,403286,940115,967457,243519,964916,963149,353514,752687,115704,691105,1039989,315706,638845,33600,693080,838916,14791,831770,964242,876143,383245,357322,493872,1035894,1018043,951249,905878,166666,1007324,488666,749415,348810,131851,222611,652392,709800,959381,594585,154185,390026,141188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]