SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507411 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507411 [ RunTime:0.004229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788974,80146,954806,276850,335067,715039,228772,492562,955521,948549,686717,956087,716198,887552,552860,19838,997814,819941,944448,629970,589975,334107,597660,917620,273727,574383,437198,35814,608284,219864,510195,807556,4644,974826,454983,794608,607599,836388,374181,372042,161157,977031,1008657,964865,101129,856805,83876,114792,106521,584962,972335,579762,288784,293406,373428,990628,471220,610219,474181,813494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]