SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404425 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404425 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712570,608788,73212,669021,941004,914650,399527,455758,601963,891994,280171,544007,495262,223370,771828,770939,977370,200861,227518,106137,419675,755219,733573,802568,867504,725047,126521,211339,258554,227308,652438,596123,951947,69252,136198,974053,705083,854896,698320,258200,787550,707200,679417,680905,1030262,704840,944389,335355,726508,493904,553625,169526,1022148,966704,453922,490384,910818,271200,10214,358134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]