SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285287 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285287 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387709,648063,862761,884902,144026,369090,502037,800368,643405,158832,417565,393393,108942,369490,721385,492930,359167,820459,1005836,170003,21492,58843,379708,665644,922294,46522,823867,438617,409779,957778,804740,99054,688694,819057,780703,957460,59237,261904,819328,275259,1044433,951647,342080,148550,355980,997350,560635,590717,590062,97226,336002,32955,421423,33042,840037,1002639,1033809,967404,1048664,894867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]