SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382685 LIMIT 1 [ RunTime:0.001620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382685 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66474,10106,836189,491005,579712,291845,780583,661057,47767,692820,896829,506978,744938,751879,862167,354051,216175,205731,274510,576578,319601,140634,109197,661164,54922,265911,553715,661155,793636,197471,533162,48724,128323,798923,284852,647406,903007,408840,452569,415964,322036,1002717,712179,778398,1040639,598695,884947,881143,421100,625458,633077,548549,461832,267963,961668,461031,519781,326147,137868,58242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]