SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403039 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403039 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349255,511476,738745,505694,42444,532239,792838,486768,1038152,423999,621010,785214,1016980,537970,985459,872439,366781,152975,743044,224708,922365,568753,709837,805551,64082,384211,623091,174130,416578,771232,119271,804788,597827,914671,192023,528493,572162,825959,139651,19365,750110,216459,610068,858767,172933,378462,818854,863533,919483,288978,750703,879962,196196,192107,271547,336232,544347,1021683,477954,189254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]