SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536543 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536543 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433437,98906,997302,547539,500079,643211,699850,1016014,173999,415694,755466,960493,861875,470270,210437,867853,477112,476563,142355,1000975,780255,194232,439325,862718,565400,38734,558397,501583,156208,311366,239044,988577,813947,365354,586214,511417,208705,1007260,715211,91573,577781,1042291,457462,597240,271312,931976,435749,76284,369188,278810,731052,373346,659969,664364,546076,9172,697128,823616,606133,395271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]